package com.pic.mgt.dao.syushin;

import java.util.List;

import org.springframework.dao.DataAccessException;

import com.pic.mgt.dao.IBasicDao;

// (送多方新增)
public interface ISyushinBusinessApDao extends IBasicDao {
	// 資料表內的欄位
	public static final String _businessName = "syushin_business_name";
	public static final String _apName = "ap_name";

	public List<String> findSyusinBusinessApNameByBizName(String businessName)
													throws DataAccessException;
	public int deleteByBizNameAndApName(String businessName, String apName)
													throws DataAccessException;
	/**
	 * 刪除無效的業務名稱資料.會與 business_list_mgt table 作比較。
	 * @return
	 * @throws DataAccessException
	 */
	public int deleteIneffectiveBusinessNameData() throws DataAccessException;
}
